﻿CREATE TABLE [dbo].[BillsDigests] (
    [Id]               NVARCHAR (100) NOT NULL,
    [Title]            NVARCHAR (MAX) NOT NULL,
    [Date]             DATETIME       NOT NULL,
    [Summary]          NVARCHAR (MAX) NOT NULL,
    [DocumentHTMLLink] NVARCHAR (MAX) NOT NULL,
    [DocumentPDFLink]  NVARCHAR (MAX) NOT NULL,
    [TitleFirstLetter] NVARCHAR (1)   NOT NULL,
    [Author]           NVARCHAR (MAX) NULL,
    [IndexedContent]   NVARCHAR (MAX) NOT NULL,
    [Bill_Id]          NVARCHAR (100) NOT NULL
);







